//=============================================================================
//===	Copyright (C) 2001-2007 Food and Agriculture Organization of the
//===	United Nations (FAO-UN), United Nations World Food Programme (WFP)
//===	and United Nations Environment Programme (UNEP)
//===
//===	This program is free software; you can redistribute it and/or modify
//===	it under the terms of the GNU General Public License as published by
//===	the Free Software Foundation; either version 2 of the License, or (at
//===	your option) any later version.
//===
//===	This program is distributed in the hope that it will be useful, but
//===	WITHOUT ANY WARRANTY; without even the implied warranty of
//===	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
//===	General Public License for more details.
//===
//===	You should have received a copy of the GNU General Public License
//===	along with this program; if not, write to the Free Software
//===	Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
//===
//===	Contact: Jeroen Ticheler - FAO - Viale delle Terme di Caracalla 2,
//===	Rome - Italy. email: geonetwork@osgeo.org
//==============================================================================

package org.fao.geonet.services.category;

import java.util.Set;
import java.util.Vector;
import jeeves.constants.Jeeves;
import jeeves.interfaces.Service;
import jeeves.resources.dbms.Dbms;
import jeeves.server.ServiceConfig;
import jeeves.server.context.ServiceContext;
import jeeves.utils.Util;
import org.fao.geonet.constants.Geonet;
import org.fao.geonet.constants.Params;
import org.fao.geonet.lib.Lib;
import org.jdom.Element;

//=============================================================================

/**
 * Update the information of a category
 */

public class Update implements Service {
	public void init(String appPath, ServiceConfig params) throws Exception {
	}

	// --------------------------------------------------------------------------
	// ---
	// --- Service
	// ---
	// --------------------------------------------------------------------------

	public Element exec(Element params, ServiceContext context)
			throws Exception {
		String id = params.getChildText(Params.ID);
		String name = Util.getParam(params, Params.NAME);

		String category_parent = Util.getParam(params, Params.PARENT_ID, null);
		Dbms dbms = (Dbms) context.getResourceManager()
				.open(Geonet.Res.MAIN_DB);

		Element elRes = new Element(Jeeves.Elem.RESPONSE);
		if (Util.getParam(params, "commit", "FALSE").toString().toUpperCase()
				.equals("TRUE")) {
			if (id == null) // For Adding new category
			{
				int newId = context.getSerialFactory().getSerial(dbms,
						"Categories");
				if (category_parent != null)
					dbms
							.execute(
									"INSERT INTO Categories(id, name,id_category_parent) VALUES (?, ?, ?)",
									new Integer(newId), name, new Integer(
											category_parent));
				else
					dbms.execute(
							"INSERT INTO Categories(id, name) VALUES (?, ?)",
							new Integer(newId), name);

				Lib.local.insert(dbms, "Categories", newId, name);

				elRes.addContent(new Element(Jeeves.Elem.OPERATION)
						.setText(Jeeves.Text.ADDED));
			} else // --- For Update
			{
				if (category_parent != null)
					dbms
							.execute(
									"UPDATE Categories SET name=?,id_category_parent=?  WHERE id=?",
									name, new Integer(category_parent),
									new Integer(id));
				else
					dbms.execute("UPDATE Categories SET name=? WHERE id=?",
							name, new Integer(id));

				elRes.addContent(new Element(Jeeves.Elem.OPERATION)
						.setText(Jeeves.Text.UPDATED));
			}
		}
		return elRes;
	}
}

// =============================================================================

